/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package tools;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

/**
 *
 * @author dimas
 */
public class CreateTableBarang {

    public static void main(String[] args) throws SQLException {
        Connection conn = Koneksi.open();
        Statement statement = conn.createStatement();
        String sql = " CREATE TABLE agen3 \n"
                + "(\n"
                + "  TANGGALKIRIM VARCHAR2(20) \n"
                + ", KODERESI VARCHAR2(20) NOT NULL \n"
                + ", NAMABARANG VARCHAR2(20) \n"
                + ", JENISBARANG VARCHAR2(20) \n"
                + ", TARIF NUMBER \n"
                + ", BERAT NUMBER \n"
                + ", HARGA NUMBER \n"
                + ", TUJUAN VARCHAR2(20) \n"
                + ", ASAL VARCHAR2(20) \n"
                + ", KETERANGAN VARCHAR2(100) \n"
                + ", TANGGALTERIMA VARCHAR2(20) \n"
           
                + ")";


        statement.executeUpdate(sql);

    }
}
